Decision Analysis Module for Excel

نویسندگان

  • Radomir Perzina
  • Jaroslav Ramik
چکیده

Abstract—The Analytic Hierarchy Process is frequently used approach for solving decision making problems. There exists wide range of software programs utilizing that approach. Their main disadvantage is that they are relatively expensive and missing intermediate calculations. This work introduces a Microsoft Excel add-in called DAME – Decision Analysis Module for Excel. Comparing to other computer programs DAME is free, can work with scenarios or multiple decision makers and displays intermediate calculations. Users can structure their decision models into three levels – scenarios/users, criteria and variants. Items on all levels can be evaluated either by weights or pair-wise comparisons. There are provided three different methods for the evaluation of the weights of criteria, the variants as well as the scenarios – Saaty’s Method, Geometric Mean Method and Fuller’s Triangle Method. Multiplicative and additive syntheses are supported. The proposed software package is demonstrated on couple of illustrating examples of real life decision problems.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

DAME - Microsoft Excel add-in for solving multicriteria decision problems with scenarios

The main goal of every economic agent is to make a good decision, especially in economic environment with many investment alternatives and evaluation criteria. The Analytic Hierarchy Process (AHP) is widely used approach for solving decision making problems. There exists wide range of computer programs that are able to help decision makers to make good decisions. Main disadvantage of those prog...

متن کامل

Microsoft Excel as a Tool for Solving Multicriteria Decision Problems

The main goal of every agent is to make a good decision. The Analytic Hierarchy Process is frequently used approach for solving decision making problems. There exists wide range of software programs utilizing that approach. Main disadvantage of those software products is that they are commercial and relatively expensive and thus it prevents them to be used by small companies, students or resear...

متن کامل

Development of a Transparent Interactive Decision Interrogator to Facilitate the Decision-Making Process in Health Care

BACKGROUND Decisions about the use of new technologies in health care are often based on complex economic models. Decision makers frequently make informal judgments about evidence, uncertainty, and the assumptions that underpin these models. OBJECTIVES Transparent interactive decision interrogator (TIDI) facilitates more formal critique of decision models by decision makers such as members of...

متن کامل

Paternity analysis in Excel

Paternity analysis using microsatellite information is a well-studied subject. These markers are ideal for parentage studies and fingerprinting, due to their high-discrimination power. This type of data is used to assign paternity, to compute the average selfing and outcrossing rates and to estimate the biparental inbreeding. There are several public domain programs that compute all this inform...

متن کامل

Mobile computing platform with decision support modules for hemotherapy.

OBJECTIVES We describe the development of a mobile computing platform (MCP) with a decision support module (DSM) for patients in our coagulation-based hemotherapy service. METHODS The core of our MCP consists of a Microsoft Excel spreadsheet template used to gather and compute data on cardiopulmonary bypass (CPB) patients intraoperatively. The DSM is embedded into the Excel file, where the us...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2014